package cn.vendpay.com.mapper;


import cn.vendcommon.com.entity.DeductionRecord;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface DeductionRecordMapper {

    @Select("insert into deduction_record (nickname, machineId, phone, deduction_time, deduction_type, status, lump_sum, deduction_items, video_url) values (#{nickname}, #{machineId}, #{phone}, #{deductionTime}, #{deductionType}, #{status}, #{lumpSum}, #{deductionItems}, #{videoUrl})")
    void insert(DeductionRecord deductionRecord);

    @Select("SELECT * FROM deduction_record ")
    List<DeductionRecord> getDeductionRecordListByPhone(String phone);

}
